package com.xr.hr.ph;

import com.bstek.dorado.common.*;
import com.bstek.dorado.data.*;
import com.bstek.dorado.data.db.DBStatement;
import com.bstek.dorado.view.*;
import com.bstek.dorado.view.data.*;
import com.bstek.dorado.view.control.*;

/**
 * oughtQueryViewModel
 */
public class oughtQueryViewModel extends DefaultViewModel {
  public void selectCompute(ParameterSet parameters, ParameterSet outParameters)
      throws Exception {
	  Dataset ds= getDataset("datasetOught");
	  DBStatement dbs=new DBStatement();
	  
	  ds.moveFirst();
	  while(!ds.isLast()){
		  dbs.setSql("begin pck_holiday.setEmpPh('"+ds.getString("OOSID")+"'); end;");
		  dbs.execute();
		  ds.moveNext();
	  }
	  dbs.close();
    //super.doUpdateData(parameters, outParameters);
  }
  
}
